
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspJob_INSERT]
(
@countryId AS int = null,
@regionId AS int = null,
@cityId AS int = null,
@fullName AS nvarchar(400) = null,
@abbreviation as nvarchar(100) = null,
@isVisible AS bit = null,
@isDeleted AS bit = null,
@createDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[Job]
(
  [CountryId],
  [RegionId],
  [CityId],
  [FullName],
  [Abbreviation],
  [IsVisible],
  [IsDeleted],
  [CreateDate],
  [LastModifiedDate]
)
VALUES
(
  @countryId,
  @regionId,
  @cityId,
  @fullName,
  @abbreviation,
  @isVisible,
  @isDeleted,
  @createDate,
  @lastModifiedDate
)

SELECT SCOPE_IDENTITY()

GO
